Tables [dbo].[AsiNrdsLog]
Properties
PropertyValue
HeapYes
Row Count0
Created2:02:43 PM Tuesday, November 29, 2011
Last Modified2:02:43 PM Tuesday, November 29, 2011
Columns
NameData TypeMax Length (Bytes)Allow Nulls
LogDateTimedatetime8
Yes
Directionnvarchar(20)40
Yes
RecordTypenvarchar(20)40
Yes
Statusnvarchar(20)40
Yes
Messagenvarchar(max)max
Yes
IDvarchar(10)10
Yes
NrdsIdvarchar(10)10
Yes
SQL Script
CREATE TABLE [dbo].[AsiNrdsLog]
(
[LogDateTime] [datetime] NULL,
[Direction] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RecordType] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NrdsId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
Uses